Carrier Payables Details Report

The Carrier Payables Details report is used to show carrier payables booked through invoicing that are payable and due to carriers. When run with the default criteria this report will balance to the mandatory general ledger account for carrier payables.

To Generate a Carrier Payables Details Report 

1. On the Primary menu, click REPORTS.
2. On the REPORTS menu, click Reports. The Nexsure Reports dialog box is displayed. 

3. In the Report Type list, select Accounting.
4. In the Report Category list, select Accounts Payables. 
5. In the Available Reports list, select Carrier Payables Details.  
6. Click OK. The summary tab is displayed. 

7. On the navigation toolbar, click New Report Criteria to go to the Nexsure Reports > Report Criteria dialog box.  

8. Under Organization Information, click [Select]. The Nexsure Organization Criteria dialog box is displayed.  

9. In the Nexsure Organization Criteria dialog box, select the desired organization information (in the Region, Territory, Branch, Department, and Unit lists) to query for the report and click Add.   

Note: If the report is being run for the entire organization it is not necessary to make a selection in the Nexsure Organization Criteria dialog box. Only one Region, Territory, or Branch may be selected for each report. When filtering by Department or Unit, add the Branch first then add the Department or Unit.  

Once information has been added to the Include list, it can be removed by selecting the item and clicking Del to remove individual items or Clear to remove all items.  

10. If the organization information is correct, click OK. The organization information selected is added to the Nexsure Reports > Report Criteria screen.  
11. In the Date Booked Information area, select the As Of Date to set the end date of the report.  

12. In the Client Information area, make selections to filter report output by Client Name or Retail Agent assigned to the client.

The available options are:

• Client Name: Select one or more client names by clicking the button. Report output will be limited to the client(s) selected if carrier payables are applicable to the client(s) selected. This filter will cause the report to be out of balance to the general ledger.
• Retail Agent: Select one or more retail agent names by clicking the button. Report output will be limited to the retail agent(s) selected if carrier payables are applicable to the client (s) where the retail agent is assigned. This filter will cause the report to be out of balance to the general ledger.

13. In the Carrier Information area, make selections to filter the report by a specific billing carrier(s). Select one or more billing carriers from by clicking the  button. Report output will be limited to the client(s) selected if carrier payables are applicable to the client(s) selected. This filter will cause the report to be out of balance to the general ledger.

14. In the Report Options area, make selections to filter the report based on invoice payable status and type.

The available options are:

• Page Break: Insert a page break between Group Field [1] option selected in the Grouping / Sorting Options area.
• Carrier Fully Paid: Show fully paid, partially paid or unpaid carrier invoices.
• Binder Bill Invoices: Show or eliminate binder bill invoices from the report. Binder bill invoices are not booked to the general ledger so if this filter is set to Yes, the report will not balance to the general ledger.
• Agency Paid?: Filter the report by the account receivable balance of the invoice. All is default and will return all invoices payable to the carrier regardless of the receivable status. When No, Paid in Full or Partially Paid is selected the report will not balance to the general ledger.

15. In the Grouping / Sorting Options area, make selections to group and sort the report to change the report layout.

The available options are:

• Group Field [1]: Apply a primary grouping by Billing Carrier, Carrier Category, Client Name, Retail Agent, or Territory (default).
• Group Field [2]: Apply a secondary grouping. This option will group transactions within the Group Field [1] selected. Selections include Bill Type, Billing Carrier, Carrier Category, Client Name, Retail Agent, and None (default).
• Sort Field [1]: Sort transactions in ascending order within groups. Selections include Amount Paid, Bill Type, Billing Carrier, Branch Comm Amount, Branch Comm Type,Client Name, Date Booked, Description, Invoice Amount, Net to Carrier, Payable Balance, Policy No,Transaction ID (default).
• Sort Order [1]: Sort within the lowest grouping option selected in ascending or descending order.

16. In the Report Format Options area, select one of the options in the Format Type list.

The available formats are: 

• PDF: This is the default setting that creates the report in a PDF format. The report data is static and cannot be manipulated.
• XLS: Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with the same formatting used in the PDF format so cells are merged and data may not be stored in individual cells.
• DOC: Microsoft Word document that can be manipulated as a .doc file.
• XLS (unformatted): Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with no formatting so cells are not merged and data is stored in individual cells, however column headers do not appear and page breaks are not inserted. 

17. In the Nexsure Reports > Report Criteria dialog box, click OK. The Carrier Payables Details report will start compiling. 

18. To update the compiling status, click Refresh on the navigation toolbar. 

19. Once the report Status is Complete, click the View icon to view the report.  

Related Topics

Working with Reports